package cn.lili.modules.member.mapper;

import cn.lili.modules.member.entity.dos.CityDistribution;
import cn.lili.modules.member.entity.dto.CityDistributionDTO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;

/**
* @author asus
* @description 针对表【li_city_distribution(城主表)】的数据库操作Mapper
* @createDate 2024-01-08 20:19:05
* @Entity cn.lili.modules.payment.domain.CityDistribution
*/
public interface CityDistributionMapper extends BaseMapper<CityDistribution> {


    Page<CityDistribution> historyEarnings(Page<CityDistribution> page, @Param("currentId") String currentId,@Param("year") int year,@Param("monthValue") int monthValue);

    /**
     * 查询城主列表,包含收益金额
     * @return
     */
    Page<CityDistribution> selectCityDistributionPage(Page page, @Param("dto") CityDistributionDTO dto);

    Double selectTotalComiss(@Param("privinceCode") String privinceCode,@Param("cityCode") String cityCode,@Param("districtCode") String districtCode,@Param("startLocalDate") String startLocalDate,@Param("endLocalDate") String endLocalDate);

}




